How to: Change a combo box to a text box in a query.
Solution:
Select the desired field in the query design grid, select 'Properties' from the 'View' menu, and make the change on the 'Lookup' tab of the displayed property sheet.
1)
If the Database window is not active,
activate the Database window.
2)
Open the query in Design view
.
3)
Click in the field for which to change the control type in the query design grid. (The cursor blinks in the field.)
Selecting a field in the query design grid
4)
Select the 'View' menu and select 'Properties'. (The Field property sheet appears.)
the Field property sheet
5)
Click the 'Lookup' tab.
6)
Select 'Text Box' from the 'Display Control' drop-down list.
the Display Control drop-down list
7)
Select the 'File' menu and select 'Save' to save the change.
8)
Select the 'File' menu and select 'Close' to close the query.